FaCfpGrantOptionsConfig_Regulatory 
Logical Entity Name  FaCfpGrantOptionsConfig_Regulatory 
Default Table Name  FaCfpGrantOptionsConfig_Regulatory 
Physical Only  NO 
Definition 
 
Note 
 

FaCfpGrantOptionsConfig_Regulatory Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FaCfpGrantOptionsConfig_RegulatoryId(PK)    char(10)  NO 
 
FaYearId(FK)    char(2)  NO 
 
SyCampusId(FK)    int  NO 
 
AdProgramVersionId(FK)    int  NO 
 
SchoolScholarship    char(10)  YES 
 
SchoolScholarshipNA    char(10)  NO 
 
StateScholarship    char(10)  YES 
 
StateScholarshipNA    char(10)  NO 
 
OtherScholarship    char(10)  YES 
 
OtherScholarshipNA    char(10)  NO 
 
EmployPaidTuition    char(10)  YES 
 
EmployPaidTuitionNA    char(10)  NO 
 
PellGrant    char(10)  YES 
 
PellGrantNA    char(10)  NO 
 
InstGrant    char(10)  YES 
 
InstGrantNA    char(10)  NO 
 
StateGrant    char(10)  YES 
 
StateGrantNA    char(10)  NO 
 
OtherGrant    char(10)  YES 
 
OtherGrantNA    char(10)  NO 
 
DateAdded    char(10)  NO 
 
DateLstMod    char(10)  NO 
 
UserId(FK)    int  NO 
 
ts    char(10)  NO 
 

FaCfpGrantOptionsConfig_Regulatory Primary and Unique Keys 
Key Name  Key Type  Keys 
UK_FaCfpGrantOptionsConfig_Regulatory_FaYearId_SyCampusId_AdProgramVersionId  Index  FaYearId, SyCampusId, AdProgramVersionId 
PK_FaCfpGrantOptionsConfig_Regulatory_FaCfpGrantOptionsConfig_RegulatoryID  PrimaryKey  FaCfpGrantOptionsConfig_RegulatoryId 

FaCfpGrantOptionsConfig_Regulatory Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdProgramVersion  Non-Identifying  One To Zero or More  FK_FaCfpGrantOptionsConfig_RegulatoryAdProgramVersionId_AdProgramVersionAdProgramVersionId      AdProgramVersionId  NO  YES 
FaYear  Non-Identifying  One To Zero or More  FK_FaCfpGrantOptionsConfig_RegulatoryFaYearId_FaYearFaYearId      FaYearId  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_FaCfpGrantOptionsConfig_RegulatorySyCampusId_SyCampusSyCampusId      SyCampusId  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_FaCfpGrantOptionsConfig_RegulatoryUserId_SyStaffSyStaffId      UserId  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

FaCfpGrantOptionsConfig_Regulatory Check Constraints 
Check Constraint Name  CheckConstraint